• 10.1 Static Column Values
• 10.2 DQ - Enrollments Active After Project Operating End Date by Project
• 10.3 DQ - Night-by-Night Enrollments with Exit Date Discrepancies by Project
• 10.4 DQ - Counts of Households with no EnrollmentCoC by Project
• 10.5 DQ – Enrollments in Non-Participating Projects
• 10.6 DQ – Enrollments Active in LSA Projects During the Report Period without Exactly One HoH
• 10.7 DQ – Enrollments Active in LSA Projects without a Valid Relationship to HoH
• 10.8 DQ – Household Entry
• 10.9 DQ – Client Entry
• 10.10 DQ – Adult/HoH Entry
• 10.11 DQ – Client Exit
• 10.12 DQ – Disabling Condition
• 10.13 DQ – Living Situation
• 10.14 DQ – Length of Stay
• 10.15 DQ – Date ES/SH/Street Homelessness Started
• 10.16 DQ – Times ES/SH/Street Homeless Last 3 Years
• 10.17 DQ – Months ES/SH/Street Homeless Last 3 Years
• 10.18 DQ – Destination
• 10.19 DQ – Date of Birth
• 10.20 LSACalculated

Report Rows 901-920 are project-level counts of data quality issues; this is to provide information to CoCs and the AHAR analysis team about specific sources of data quality issues.

10.1 Static Column Values

lsa_Calculated Column	Requirements
Cohort	1
Universe	10
HHType	0
Population	0
SystemPath	-1
ProjectID	Must match Project.ProjectID.
ReportID	Must match LSAReport.ReportID

ReportRow numbers and Value criteria are defined in the following sections.

10.2 DQ - Enrollments Active After Project Operating End Date by Project

flowchart LR 
    subgraph grp
        direction TD
        T1([tlsa_Enrollment]) ~~~ H1[(hmis_Exit
        hmis_Project)]
    end

    L1[[lsa_Report]]-->
    grp -->
	L2[[lsa_Calculated]]

    L1:::LSA
    L2:::LSA
    T1:::Temp
    H1:::HMIS
    grp:::Box

    classDef Temp stroke:#FF5978, fill:#FFDFE5, color:#8E2236
	classDef LSA stroke:#FBB35A, fill:#FFEFDB, color:#8F632D 
	classDef HMIS stroke:#374D7C, fill:#E2EBFF, color:#374D7C
	classDef Box stroke:#999, fill:none, color:#FFFFFF 

ReportRow 901 counts enrollments in tlsa_Enrollment with no ExitDate in hmis_Exit for projects that have an OperatingEndDate between ReportStart and ReportEnd.

ReportRow 902 counts enrollments in tlsa_Enrollment where OperatingEndDate is between ReportStart and ReportEnd and hmis_Exit.ExitDate > OperatingEndDate.

These counts are grouped by ProjectID.

Value = a count of distinct EnrollmentIDs in tlsa_Enrollment where:

• ExitDate is NULL (ReportRow 901); or
• ExitDate > OperatingEndDate (ReportRow 902);

AND:

• OperatingEndDate between ReportStart and ReportEnd

Records are only included when the count is greater than zero.

10.3 DQ - Night-by-Night Enrollments with Exit Date Discrepancies by Project

flowchart LR 
    subgraph grp
        direction TD
        T1([tlsa_Enrollment]) ~~~ H1[(hmis_Project
        hmis_Exit
        hmis_Services)]
    end

    L1[[lsa_Report]]-->
    grp -->
	L2[[lsa_Calculated]]

    L1:::LSA
    L2:::LSA
    T1:::Temp
    H1:::HMIS
    grp:::Box

    classDef Temp stroke:#FF5978, fill:#FFDFE5, color:#8E2236
	classDef LSA stroke:#FBB35A, fill:#FFEFDB, color:#8F632D 
	classDef HMIS stroke:#374D7C, fill:#E2EBFF, color:#374D7C
	classDef Box stroke:#999, fill:none, color:#FFFFFF 

ReportRow 903 counts enrollments without an ExitDate as of ReportEnd (i.e., ExitDate is after ReportEnd or is NULL) in continuum night-by-night ES projects that have no record of a bed night in the 90 days ending on ReportEnd.

ReportRow 904 counts enrollments with an ExitDate in continuum night-by-night ES projects between ReportStart and ReportEnd and where there is no record of a bed night on [ExitDate – 1 day].

Value = a count of distinct EnrollmentIDs in hmis_Enrollment where:

• hmis_Project.ProjectType = 1; and
• hmis_Project.ContinuumProject = 1; and
• There is a record for the HouseholdID in tlsa_HHID (i.e., the household was active in ReportCoC)
  • ExitDate is NULL or ExitDate > ReportEnd; and
    • LastBedNight <= [CohortEnd – 90 days](ReportRow 903); or
  • ExitDate between ReportStart and ReportEnd and LastBedNight <> ExitDate – 1 day] (ReportRow 904)

In this context, LastBedNight is the most recent bed night for the enrollment on or before ReportEnd.

10.4 DQ - Counts of Households with no EnrollmentCoC by Project

flowchart LR 

    L1[[lsa_Report
    lsa_Project]]-->
    H1[(hmis_Enrollment
        hmis_Exit)] -->
	L2[[lsa_Calculated]]

    L1:::LSA
    L2:::LSA

    H1:::HMIS

    classDef Temp stroke:#FF5978, fill:#FFDFE5, color:#8E2236
	classDef LSA stroke:#FBB35A, fill:#FFEFDB, color:#8F632D 
	classDef HMIS stroke:#374D7C, fill:#E2EBFF, color:#374D7C
	classDef Box stroke:#999, fill:none, color:#FFFFFF 

ReportRow 905 counts households that are active in a continuum ES/SH/TH/RRH/PSH/RRHSO project during the report period and whose enrollment(s) are not associated with any CoC.

Value = a count of distinct HouseholdIDs in hmis_Enrollment where:

• ProjectID = lsa_Project.ProjectID and ProjectType is not in (9,10); and
• EntryDate <= ReportEnd; and
• ExitDate is NULL or
  • ExitDate >= ReportStart; and
  • ExitDate > EntryDate
• There is no hmis_Enrollment record where:
  • EnrollmentCoC is not NULL; and
  • RelationshipToHoH = 1

10.5 DQ – Enrollments in Non-Participating Projects

flowchart LR 

    L1[[lsa_Report
    lsa_Project
    lsa_HMISParticipation]]-->
    H1[(hmis_Enrollment
        hmis_Exit)] -->
	L2[[lsa_Calculated]]

    L1:::LSA
    L2:::LSA

    H1:::HMIS

    classDef Temp stroke:#FF5978, fill:#FFDFE5, color:#8E2236
	classDef LSA stroke:#FBB35A, fill:#FFEFDB, color:#8F632D 
	classDef HMIS stroke:#374D7C, fill:#E2EBFF, color:#374D7C
	classDef Box stroke:#999, fill:none, color:#FFFFFF 

ReportRow 906 counts enrollments in hmis_Enrollment that are active during the report period and overlap with a period in which the project was not identified as participating in HMIS. This may include enrollments that were excluded from the LSA entirely and/or enrollments used in LSA reporting with adjusted entry/exit dates.

Value = a count of distinct EnrollmentIDs in hmis_Enrollment where:

• ProjectID = lsa_Project.ProjectID and ProjectType is not in (9,10); and
• EntryDate <= ReportEnd; and
• ExitDate is NULL or
  • ExitDate >= ReportStart; and
  • ExitDate > EntryDate
• EnrollmentCoC = ReportCoC for the head of household’s enrollment; and
• There is no record in lsa_HMISParticipation for the ProjectID where:
• HMISParticipationType = 1 and HMISParticipationStatusStartDate <= EntryDate; and
  • HMISParticipationStatusEndDate is null; or
  • HMISParticipationStatusEndDate >= ExitDate; or
  • ExitDate is null and HMISParticipationStatusEndDate > ReportEnd

10.6 DQ – Enrollments Active in LSA Projects During the Report Period without Exactly One HoH

flowchart LR 

    L1[[lsa_Report
    lsa_Project]]-->
    H1[(hmis_Enrollment
        hmis_Exit)] -->
	L2[[lsa_Calculated]]

    L1:::LSA
    L2:::LSA

    H1:::HMIS

    classDef Temp stroke:#FF5978, fill:#FFDFE5, color:#8E2236
	classDef LSA stroke:#FBB35A, fill:#FFEFDB, color:#8F632D 
	classDef HMIS stroke:#374D7C, fill:#E2EBFF, color:#374D7C
	classDef Box stroke:#999, fill:none, color:#FFFFFF 

ReportRow 907 counts enrollments that are active in a continuum ES/SH/TH/RRH/PSH/RRHSO project during the report period and do not have exactly one HoH.

Value = a count of distinct EnrollmentIDs in hmis_Enrollment where:

• ProjectID = lsa_Project.ProjectID and lsa_Project.ProjectType is not in (9,10)
• EnrollmentCoC for the head of household’s enrollment = ReportCoC
• ExitDate is null or ExitDate >= ReportStart; and
• ExitDate is null or ExitDate > EntryDate; and
• The count of PersonalIDs in hmis_Enrollment with the same HouseholdID and a RelationshipToHoH = 1 <> 1

10.7 DQ – Enrollments Active in LSA Projects without a Valid Relationship to HoH

flowchart LR 

    L1[[lsa_Report
    lsa_Project]]-->
    H1[(hmis_Enrollment
        hmis_Exit)] -->
	L2[[lsa_Calculated]]

    L1:::LSA
    L2:::LSA

    H1:::HMIS

    classDef Temp stroke:#FF5978, fill:#FFDFE5, color:#8E2236
	classDef LSA stroke:#FBB35A, fill:#FFEFDB, color:#8F632D 
	classDef HMIS stroke:#374D7C, fill:#E2EBFF, color:#374D7C
	classDef Box stroke:#999, fill:none, color:#FFFFFF 

ReportRow 908 counts enrollments that are active in a continuum ES/SH/TH/RRH/PSH/RRHSO project during the report period and do not have a valid RelationshipToHoH..

Value = a count of distinct EnrollmentIDs in hmis_Enrollment where:

• ProjectID = lsa_Project.ProjectID and lsa_Project.ProjectType is not in (9,10)
• EnrollmentCoC for the head of household’s enrollment = ReportCoC
• ExitDate is null or ExitDate >= ReportStart; and
• ExitDate is null or ExitDate > EntryDate; and
• RelationshipToHoH is NULL or not in (1,2,3,4,5)

10.8 DQ – Household Entry

flowchart LR 

    T1([tlsa_HHID]) -->
	L2[[lsa_Calculated]]


    L2:::LSA

    T1:::Temp

    classDef Temp stroke:#FF5978, fill:#FFDFE5, color:#8E2236
	classDef LSA stroke:#FBB35A, fill:#FFEFDB, color:#8F632D 
	classDef HMIS stroke:#374D7C, fill:#E2EBFF, color:#374D7C
	classDef Box stroke:#999, fill:none, color:#FFFFFF 

The Value for ReportRow 909 is a count of distinct HouseholdIDs in tlsa_HHID where AIR = 1 or (LSAScope <> 3 and Active = 1).

10.9 DQ – Client Entry

flowchart LR 

    T1([tlsa_Enrollment]) -->
	L2[[lsa_Calculated]]

    L2:::LSA

    T1:::Temp

    classDef Temp stroke:#FF5978, fill:#FFDFE5, color:#8E2236
	classDef LSA stroke:#FBB35A, fill:#FFEFDB, color:#8F632D 
	classDef HMIS stroke:#374D7C, fill:#E2EBFF, color:#374D7C
	classDef Box stroke:#999, fill:none, color:#FFFFFF 

The Value for ReportRow 910 is a count of distinct EnrollmentIDs in tlsa_Enrollment where AIR = 1 or (LSAScope <> 3 and Active = 1).

10.10 DQ – Adult/HoH Entry

flowchart LR 

    T1([tlsa_Enrollment]) -->
	L2[[lsa_Calculated]]

    L2:::LSA

    T1:::Temp

    classDef Temp stroke:#FF5978, fill:#FFDFE5, color:#8E2236
	classDef LSA stroke:#FBB35A, fill:#FFEFDB, color:#8F632D 
	classDef HMIS stroke:#374D7C, fill:#E2EBFF, color:#374D7C
	classDef Box stroke:#999, fill:none, color:#FFFFFF 

The Value for ReportRow 911 is a count of distinct EnrollmentIDs in tlsa_Enrollment where AIR = 1 or (LSAScope <> 3 and Active = 1) and:

• ActiveAge between 18 and 65; or
• RelationshipToHoH = 1.

10.11 DQ – Client Exit

flowchart LR 

    T1([tlsa_Enrollment]) -->
	L2[[lsa_Calculated]]

    L2:::LSA

    T1:::Temp

    classDef Temp stroke:#FF5978, fill:#FFDFE5, color:#8E2236
	classDef LSA stroke:#FBB35A, fill:#FFEFDB, color:#8F632D 
	classDef HMIS stroke:#374D7C, fill:#E2EBFF, color:#374D7C
	classDef Box stroke:#999, fill:none, color:#FFFFFF 

The Value for ReportRow 912 is a count of distinct PersonalIDs in tlsa_Enrollment where AIR = 1 or (LSAScope <> 3 and Active = 1) and ExitDate is not NULL.

10.12 DQ – Disabling Condition

flowchart LR 

    T1([tlsa_Enrollment]) -->
	L2[[lsa_Calculated]]

    L2:::LSA

    T1:::Temp

    classDef Temp stroke:#FF5978, fill:#FFDFE5, color:#8E2236
	classDef LSA stroke:#FBB35A, fill:#FFEFDB, color:#8F632D 
	classDef HMIS stroke:#374D7C, fill:#E2EBFF, color:#374D7C
	classDef Box stroke:#999, fill:none, color:#FFFFFF 

This is a subset of ClientEntry (the Value for ReportRow 910).

The Value for ReportRow 913 is a count of distinct EnrollmentIDs in tlsa_Enrollment for ProjectIDs in lsa_Project where where AIR = 1 or (LSAScope <> 3 and Active = 1) and:

• DisabilityStatus = 99.

10.13 DQ – Living Situation

flowchart LR 

    T1([tlsa_Enrollment]) -->
	L2[[lsa_Calculated]]

    L2:::LSA

    T1:::Temp

    classDef Temp stroke:#FF5978, fill:#FFDFE5, color:#8E2236
	classDef LSA stroke:#FBB35A, fill:#FFEFDB, color:#8F632D 
	classDef HMIS stroke:#374D7C, fill:#E2EBFF, color:#374D7C
	classDef Box stroke:#999, fill:none, color:#FFFFFF 

This is a subset of AdultHoHEntry(the Value for ReportRow 911).

The Value for ReportRow 914 is a count of distinct EnrollmentIDs in tlsa_Enrollment for ProjectIDs in lsa_Project where where AIR = 1 or (LSAScope <> 3 and Active = 1) and:

• LivingSituation in (8,9,99) or is NULL; and
• ActiveAge between 18 and 65 or RelationshipToHoH = 1

10.14 DQ – Length of Stay

flowchart LR 

    T1([tlsa_Enrollment]) -->
    H1[(hmis_Enrollment)] -->
	L2[[lsa_Calculated]]

    L2:::LSA
    H1:::HMIS
    T1:::Temp

    classDef Temp stroke:#FF5978, fill:#FFDFE5, color:#8E2236
	classDef LSA stroke:#FBB35A, fill:#FFEFDB, color:#8F632D 
	classDef HMIS stroke:#374D7C, fill:#E2EBFF, color:#374D7C
	classDef Box stroke:#999, fill:none, color:#FFFFFF 

This is a subset of AdultHoHEntry (the Value for ReportRow 911).

The Value for ReportRow 915 is a count of distinct EnrollmentIDs in tlsa_Enrollment for ProjectIDs in lsa_Project where where AIR = 1 or (LSAScope <> 3 and Active = 1) and:

• LengthOfStay in (8,9,99) or is NULL; and
• ActiveAge between 18 and 65 or RelationshipToHoH = 1

10.15 DQ – Date ES/SH/Street Homelessness Started

flowchart LR 

    T1([tlsa_Enrollment]) -->
    H1[(hmis_Enrollment)] -->
	L2[[lsa_Calculated]]

    L2:::LSA
    H1:::HMIS
    T1:::Temp

    classDef Temp stroke:#FF5978, fill:#FFDFE5, color:#8E2236
	classDef LSA stroke:#FBB35A, fill:#FFEFDB, color:#8F632D 
	classDef HMIS stroke:#374D7C, fill:#E2EBFF, color:#374D7C
	classDef Box stroke:#999, fill:none, color:#FFFFFF 

This is a subset of AdultHoHEntry(the Value for ReportRow 911).

The Value for ReportRow 916 is a count of distinct EnrollmentIDs in tlsa_Enrollment for ProjectIDs in lsa_Project where where AIR = 1 or (LSAScope <> 3 and Active = 1) and:

• ActiveAge between 18 and 65 or RelationshipToHoH = 1; and
• DateToStreetESSH > EntryDate; or
• DateToStreetESSH is NULL; and
  • LSAProjectType in (0,1,8); or
  • LivingSituation in (101,116,118); or
  • PreviousStreetESSH = 1.

10.16 DQ – Times ES/SH/Street Homeless Last 3 Years

flowchart LR 

    T1([tlsa_Enrollment]) -->
    H1[(hmis_Enrollment)] -->
	L2[[lsa_Calculated]]

    L2:::LSA
    H1:::HMIS
    T1:::Temp

    classDef Temp stroke:#FF5978, fill:#FFDFE5, color:#8E2236
	classDef LSA stroke:#FBB35A, fill:#FFEFDB, color:#8F632D 
	classDef HMIS stroke:#374D7C, fill:#E2EBFF, color:#374D7C
	classDef Box stroke:#999, fill:none, color:#FFFFFF 

This is a subset of AdultHoHEntry (the Value for ReportRow 911).

The Value for ReportRow 917 is a count of distinct EnrollmentIDs in tlsa_Enrollment for ProjectIDs in lsa_Project where where AIR = 1 or (LSAScope <> 3 and Active = 1) and:

• ActiveAge between 18 and 65 or RelationshipToHoH = 1; and
• TimesHomelessPastThreeYears is NULL or not in (1,2,3,4); and
  • LSAProjectType in (0,1,8); or
  • LivingSituation in (101,116,118); or
  • PreviousStreetESSH = 1.

10.17 DQ – Months ES/SH/Street Homeless Last 3 Years

flowchart LR 

    T1([tlsa_Enrollment]) -->
    H1[(hmis_Enrollment)] -->
	L2[[lsa_Calculated]]

    L2:::LSA
    H1:::HMIS
    T1:::Temp

    classDef Temp stroke:#FF5978, fill:#FFDFE5, color:#8E2236
	classDef LSA stroke:#FBB35A, fill:#FFEFDB, color:#8F632D 
	classDef HMIS stroke:#374D7C, fill:#E2EBFF, color:#374D7C
	classDef Box stroke:#999, fill:none, color:#FFFFFF 

This is a subset of AdultHoHEntry(the Value for ReportRow 911).

The Value for ReportRow 918 is a count of distinct EnrollmentIDs in tlsa_Enrollment for ProjectIDs in lsa_Project where where AIR = 1 or (LSAScope <> 3 and Active = 1) and:

• ActiveAge between 18 and 65 or RelationshipToHoH = 1; and
• MonthsHomelessPastThreeYears is NULL or not between 101 and 113; and
  • LSAProjectType in (0,1,8); or
  • LivingSituation in (101,116,118); or
  • PreviousStreetESSH = 1.

10.18 DQ – Destination

flowchart LR 

    T1([tlsa_Enrollment]) -->
    H1[(hmis_Exit)] -->
	L2[[lsa_Calculated]]

    L2:::LSA
    H1:::HMIS
    T1:::Temp

    classDef Temp stroke:#FF5978, fill:#FFDFE5, color:#8E2236
	classDef LSA stroke:#FBB35A, fill:#FFEFDB, color:#8F632D 
	classDef HMIS stroke:#374D7C, fill:#E2EBFF, color:#374D7C
	classDef Box stroke:#999, fill:none, color:#FFFFFF 

This is a subset of ClientExit (the Value for ReportRow 912).

The Value for ReportRow 919 is a count of distinct EnrollmentIDs in tlsa_Enrollment for ProjectIDs in lsa_Project where where AIR = 1 or (LSAScope <> 3 and Active = 1) and:

• ExitDate is not NULL; and
  • Destination is NULL or in (8,9,17,30,99) or
  • Destination = 435 and hmis_Exit.DestinationSubsidyType is NULL

10.19 DQ – Date of Birth

flowchart LR 

    T1([tlsa_Enrollment]) -->
	L2[[lsa_Calculated]]

    L2:::LSA
    T1:::Temp

    classDef Temp stroke:#FF5978, fill:#FFDFE5, color:#8E2236
	classDef LSA stroke:#FBB35A, fill:#FFEFDB, color:#8F632D 
	classDef HMIS stroke:#374D7C, fill:#E2EBFF, color:#374D7C
	classDef Box stroke:#999, fill:none, color:#FFFFFF 

The Value for ReportRow 920 is a count of distinct PersonalIDs in tlsa_Enrollment for ProjectIDs in lsa_Project where where AIR = 1 or (LSAScope <> 3 and Active = 1) and ActiveAge in (98,99).

10.20 LSACalculated

LSACalculated has nine columns. Except for ProjectID, the datatype for all columns is integer and none may be NULL.

Value for every record must be greater than zero; neither averages nor counts are generated when there are no records that meet criteria specific to the household type, population, cohort, etc.

The data type for the ProjectID column is an alphanumeric string of no more than 32 characters.

• If Universe <> 10, ProjectID must be NULL.
• If Universe = 10, ProjectID may not be NULL.